2025-06-08 17:43:42,261 [ 362816 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2025-06-08 17:43:42,261 [ 362816 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2025-06-08 17:43:42,261 [ 362816 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2025-06-08 17:43:42,261 [ 362816 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_a2b39n --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: order-1.0.1, random-0.2, timeout-2.2.0, repeat-0.9.3, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_replicated_user_defined_functions/test.py::test_create_and_drop test_reloading_settings_from_users_xml/test.py::test_force_reload test_replication_credentials/test.py::test_credentials_and_no_credentials test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_mutations/test.py::test_mutations test_quota/test.py::test_add_remove_interval test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_ssh_keys_authentication/test.py::test_ecdsa [gw8] [ 1%] PASSED test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 [gw8] [ 2%] PASSED test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase [gw8] [ 3%] PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw8] [ 4%] PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw4] [ 5%] PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_s3_with_https/test.py::test_s3_with_https[s3_secure] [gw4] [ 6%] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum [gw3] [ 7%] FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml [gw1] [ 8%] PASSED test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw4] [ 9%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int [gw2] [ 10%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] [gw4] [ 11%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload [gw2] [ 12%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] [gw0] [ 13%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] [gw0] [ 14%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] [gw4] [ 15%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw2] [ 16%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] test_replicated_user_defined_functions/test.py::test_create_and_replace [gw0] [ 17%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] [gw0] [ 18%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_and_delete_replicated[USER] [gw0] [ 19%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] test_replicated_users/test.py::test_create_replicated[QUOTA] [gw2] [ 20%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists [gw4] [ 21%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw1] [ 22%] PASSED test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters [gw2] [ 23%] PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper [gw5] [ 24%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper [gw0] [ 25%] PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] test_replicated_users/test.py::test_create_replicated[ROLE] [gw1] [ 26%] PASSED test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases [gw0] [ 27%] PASSED test_replicated_users/test.py::test_create_replicated[ROLE] test_replicated_users/test.py::test_create_replicated[ROW_POLICY] [gw1] [ 28%] PASSED test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges [gw0] [ 29%] PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw0] [ 30%] PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated[USER] [gw1] [ 31%] PASSED test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist [gw8] [ 32%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw8] [ 33%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw0] [ 34%] PASSED test_replicated_users/test.py::test_create_replicated[USER] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] [gw1] [ 35%] PASSED test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables [gw0] [ 36%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] [gw0] [ 37%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] [gw1] [ 38%] PASSED test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection [gw0] [ 39%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] [gw3] [ 40%] FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw0] [ 41%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw5] [ 42%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper [gw0] [ 43%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] [gw5] [ 44%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper [gw0] [ 45%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] [gw0] [ 46%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] [gw0] [ 47%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] [gw0] [ 48%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster[USER] [gw0] [ 49%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] [gw0] [ 50%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] [gw1] [ 51%] PASSED test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management [gw0] [ 52%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] [gw0] [ 53%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] [gw3] [ 54%] FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw5] [ 55%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 56%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes [gw0] [ 57%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] [gw1] [ 58%] PASSED test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota [gw5] [ 59%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 60%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] [gw3] [ 61%] FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes [gw0] [ 62%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] test_replicated_users/test.py::test_reload_zookeeper test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots [gw1] [ 63%] PASSED test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts [gw3] [ 64%] FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw1] [ 65%] PASSED test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml [gw2] [ 66%] PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication [gw3] [ 67%] FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw7] [ 68%] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials [gw1] [ 69%] PASSED test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer [gw2] [ 70%] PASSED test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation [gw2] [ 71%] PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_render_log_file_name_templates/test.py::test_check_file_names [gw7] [ 72%] PASSED test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials [gw1] [ 73%] PASSED test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota [gw1] [ 74%] PASSED test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota [gw7] [ 75%] PASSED test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials [gw2] [ 76%] PASSED test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw1] [ 77%] PASSED test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly [gw1] [ 78%] PASSED test_quota/test.py::test_users_xml_is_readonly [gw8] [ 79%] PASSED test_render_log_file_name_templates/test.py::test_check_file_names [gw0] [ 80%] PASSED test_replicated_users/test.py::test_reload_zookeeper test_replicated_users/test.py::test_rename_replicated[QUOTA] [gw7] [ 81%] PASSED test_replication_credentials/test.py::test_same_credentials [gw0] [ 82%] PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] test_replicated_users/test.py::test_rename_replicated[ROLE] [gw0] [ 83%] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] [gw0] [ 84%] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] [gw0] [ 85%] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_rename_replicated[USER] [gw9] [ 86%] PASSED test_replicated_mutations/test.py::test_mutations test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] [gw0] [ 87%] PASSED test_replicated_users/test.py::test_rename_replicated[USER] test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw4] [ 88%] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw6] [ 89%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] [gw8] [ 90%] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw6] [ 91%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] test_replicating_constants/test.py::test_different_versions test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] [gw6] [ 92%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw6] [ 93%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw5] [ 94%] PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 [gw2] [ 95%] PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw4] [ 96%] PASSED test_replicating_constants/test.py::test_different_versions test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss [gw9] [ 97%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw5] [ 98%] PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw9] [ 99%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] [gw4] [100%] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss =================================== FAILURES =================================== _____________________________ test_replicating_dml _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_replicating_dml(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table(f"postgresql_replica_{i}") instance.query( "INSERT INTO postgres_database.postgresql_replica_{} SELECT number, {} from numbers(50)".format( i, i ) ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 50 + number, {i} from numbers(1000)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:100: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f6f2cc88ac3 E 20. ? @ 0x00007f6f2cd1a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml PostgreSQL is available - running test ---------------------------- Captured stderr setup ----------------------------- Command:['docker ps | wc -l'] Stdout:1 No running containers Pruning Docker networks Command:['docker network prune --force'] Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] Stdout:net.ipv4.ip_local_port_range = 55000 65535 Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py Cluster start called. is_up=False Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stdout:Total reclaimed space: 0B Images pruned Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:1 Setup directory for instance: instance Create directory for configuration generated in this helper Create directory for common tests configuration Copy common configuration from helpers Generate and write macros file Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found http://localhost:None "GET /version HTTP/1.1" 200 826 Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] Stderr:Pulling instance ... Stderr:Pulling postgres1 ... Stderr:Pulling postgres1 ... pulling from library/postgres Stderr:Pulling instance ... pulling from altinityinfra/integr... Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... Stderr:Pulling postgres1 ... status: image is up to date for p... Stderr:Pulling postgres1 ... done Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... Stderr:Pulling instance ... status: image is up to date for a... Stderr:Pulling instance ... done Setup Postgres Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown Stderr:docker-py version: Stderr:CPython version: 3.10.12 Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', Stderr: 'BridgeNfIp6tables': True, Stderr: 'BridgeNfIptables': True, Stderr: 'CPUSet': True, Stderr: 'CPUShares': True, Stderr: 'CgroupDriver': 'cgroupfs', Stderr: 'CgroupVersion': '2', Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, Stderr: 'Containers': 1, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': '7ad3aad10e6980e459b77f82f650071ff4c1e374a522d8c1feaac2a78b9afc75', Stderr: 'Warning': ''} Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.parallel.feed_queue: Pending: {} Stderr:compose.parallel.feed_queue: Starting producer thread for Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], Stderr: 'Links': [], Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, Stderr: 'Mounts': [{'ReadOnly': None, Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', Stderr: 'Target': '/postgres/', Stderr: 'Type': 'bind'}], Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', Stderr: 'PortBindings': {}, Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', Stderr: 'Warnings': []} Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', Stderr: 'Args': ['postgres', Stderr: '-c', Stderr: 'wal_level=logical', Stderr: '-c', Stderr: 'max_replication_slots=4', Stderr: '-c', Stderr: 'logging_collector=on', Stderr: '-c', Stderr: 'log_directory=/postgres/logs', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', 'roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', 'postgre-sql.local', '8de5717b49a6'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a') Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.parallel_execute_iter: Finished processing: Stderr:compose.parallel.feed_queue: Pending: set() get_instance_ip instance_name=postgres1 http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Postgres Started ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done ClickHouse instance created get_instance_ip instance_name=instance http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None Waiting for ClickHouse start in instance, ip: 172.16.4.3... http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None ClickHouse instance started Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ------------------------------ Captured log setup ------------------------------ 2025-06-08 17:43:45 [ 511 ] DEBUG : Command:['docker ps | wc -l'] (cluster.py:113, run_and_check) 2025-06-08 17:43:45 [ 511 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-08 17:43:45 [ 511 ] DEBUG : No running containers (conftest.py:92, cleanup_environment) 2025-06-08 17:43:45 [ 511 ] DEBUG : Pruning Docker networks (conftest.py:94, cleanup_environment) 2025-06-08 17:43:45 [ 511 ] DEBUG : Command:['docker network prune --force'] (cluster.py:113, run_and_check) 2025-06-08 17:43:45 [ 511 ] DEBUG : Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] (cluster.py:113, run_and_check) 2025-06-08 17:43:45 [ 511 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:121, run_and_check) 2025-06-08 17:43:45 [ 511 ] INFO : Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py (cluster.py:2659, start) 2025-06-08 17:43:45 [ 511 ] DEBUG : Cluster start called. is_up=False (cluster.py:2666, start) 2025-06-08 17:43:45 [ 511 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-08 17:43:45 [ 511 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-08 17:43:45 [ 511 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-08 17:43:45 [ 511 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-08 17:43:45 [ 511 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-08 17:43:45 [ 511 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-08 17:43:46 [ 511 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-08 17:43:46 [ 511 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-08 17:43:46 [ 511 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-08 17:43:46 [ 511 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:121, run_and_check) 2025-06-08 17:43:46 [ 511 ] DEBUG : Images pruned (cluster.py:854, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-08 17:43:46 [ 511 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-08 17:43:46 [ 511 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-08 17:43:46 [ 511 ] DEBUG : Setup directory for instance: instance (cluster.py:2679, start) 2025-06-08 17:43:46 [ 511 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4383, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Create directory for common tests configuration (cluster.py:4388, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Copy common configuration from helpers (cluster.py:4408, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Generate and write macros file (cluster.py:4441, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d (cluster.py:4471, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database (cluster.py:4488, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs (cluster.py:4499, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4582, create_dir) 2025-06-08 17:43:46 [ 511 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env (cluster.py:86, _create_env_file) 2025-06-08 17:43:46 [ 511 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-08 17:43:46 [ 511 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-08 17:43:46 [ 511 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-08 17:43:46 [ 511 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-08 17:43:46 [ 511 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:546, _make_request) 2025-06-08 17:43:46 [ 511 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] (cluster.py:113, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling instance ... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling postgres1 ... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling postgres1 ... pulling from library/postgres (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling instance ... pulling from altinityinfra/integr... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling postgres1 ... status: image is up to date for p... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling postgres1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling instance ... status: image is up to date for a... (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Stderr:Pulling instance ... done (cluster.py:123, run_and_check) 2025-06-08 17:43:57 [ 511 ] DEBUG : Setup Postgres (cluster.py:2791, start) 2025-06-08 17:43:57 [ 511 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] (cluster.py:113, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:docker-py version: (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:CPython version: 3.10.12 (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'BridgeNfIp6tables': True, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'BridgeNfIptables': True, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'CPUSet': True, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'CPUShares': True, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'CgroupDriver': 'cgroupfs', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'CgroupVersion': '2', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Containers': 1, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': '7ad3aad10e6980e459b77f82f650071ff4c1e374a522d8c1feaac2a78b9afc75', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Warning': ''} (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {} (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Links': [], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Mounts': [{'ReadOnly': None, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Target': '/postgres/', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Type': 'bind'}], (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'PortBindings': {}, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Warnings': []} (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'Args': ['postgres', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'wal_level=logical', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'max_replication_slots=4', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'logging_collector=on', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr: 'log_directory=/postgres/logs', (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', 'roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', 'postgre-sql.local', '8de5717b49a6'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('8de5717b49a6b3993b480c695aa8412a2a54903de430e2e81d4cfdf478b7044a') (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-08 17:43:58 [ 511 ] DEBUG : get_instance_ip instance_name=postgres1 (cluster.py:2008, get_instance_ip) 2025-06-08 17:43:58 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:43:58 [ 511 ] DEBUG : Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-08 17:43:58 [ 511 ] DEBUG : Can't connect to Postgres connection to server at "172.16.4.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-08 17:43:59 [ 511 ] DEBUG : Postgres Started (cluster.py:2248, wait_postgres_to_start) 2025-06-08 17:43:59 [ 511 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') (cluster.py:3002, start) 2025-06-08 17:43:59 [ 511 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] (cluster.py:113, run_and_check) 2025-06-08 17:44:00 [ 511 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:44:00 [ 511 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:44:00 [ 511 ] DEBUG : ClickHouse instance created (cluster.py:3010, start) 2025-06-08 17:44:00 [ 511 ] DEBUG : get_instance_ip instance_name=instance (cluster.py:2008, get_instance_ip) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : Waiting for ClickHouse start in instance, ip: 172.16.4.3... (cluster.py:3017, start) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:00 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : http://localhost:None "GET /v1.42/containers/e0d8a34d8f3542574e8d6fc4d0e0b6e0bb93117e3074246aedf29b122d13a9dd/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-08 17:44:01 [ 511 ] DEBUG : ClickHouse instance started (cluster.py:3021, start) 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:02 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:03 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:03 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:03 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:03 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:03 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-08 17:44:04 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-08 17:44:04 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-08 17:44:04 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-08 17:44:04 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-08 17:44:04 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:05 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:05 [ 511 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:05 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:05 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:05 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:06 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________ test_restart_server_while_replication_startup_not_finished __________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_restart_server_while_replication_startup_not_finished(started_cluster): NUM_TABLES = 5 pg_manager.create_and_fill_postgres_tables(NUM_TABLES, 100000) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) time.sleep(1) instance.restart_clickhouse() > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:774: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f2f9bb78ac3 E 20. ? @ 0x00007f2f9bc0a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] Stdout: PID TTY TIME CMD Stdout: 8 ? 00:00:05 clickhouse run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] No clickhouse process running. Start new one. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:753 Clickhouse process running. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:753 Executing query select 20 on instance Executing query select 20 on instance Executing query select 20 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:06 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-08 17:44:06 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-08 17:44:07 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-08 17:44:07 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-08 17:44:08 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-08 17:44:08 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:09 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:09 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:10 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:10 [ 511 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] (cluster.py:113, run_and_check) 2025-06-08 17:44:10 [ 511 ] DEBUG : Stdout: PID TTY TIME CMD (cluster.py:121, run_and_check) 2025-06-08 17:44:10 [ 511 ] DEBUG : Stdout: 8 ? 00:00:05 clickhouse (cluster.py:121, run_and_check) 2025-06-08 17:44:10 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:10 [ 511 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] (cluster.py:113, run_and_check) 2025-06-08 17:44:10 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:10 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:10 [ 511 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-08 17:44:11 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:11 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:11 [ 511 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-08 17:44:12 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:12 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:12 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:12 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:12 [ 511 ] DEBUG : No clickhouse process running. Start new one. (cluster.py:3817, start_clickhouse) 2025-06-08 17:44:12 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:12 [ 511 ] DEBUG : Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:113, run_and_check) 2025-06-08 17:44:13 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:13 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:14 [ 511 ] DEBUG : Stdout:753 (cluster.py:121, run_and_check) 2025-06-08 17:44:14 [ 511 ] DEBUG : Clickhouse process running. (cluster.py:3828, start_clickhouse) 2025-06-08 17:44:14 [ 511 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-08 17:44:14 [ 511 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-08 17:44:14 [ 511 ] DEBUG : Stdout:753 (cluster.py:121, run_and_check) 2025-06-08 17:44:14 [ 511 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-08 17:44:14 [ 511 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-08 17:44:15 [ 511 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-08 17:44:15 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:15 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_single_transaction ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_single_transaction(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, auto_commit=False, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) conn.commit() pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) assert_nested_table_is_created(instance, table_name) for query in queries: print("query {}".format(query)) cursor.execute(query.format(0)) time.sleep(5) result = instance.query(f"select count() from test_database.{table_name}") # no commit yet assert int(result) == 0 conn.commit() > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:531: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f2f9bb78ac3 E 20. ? @ 0x00007f2f9bc0a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database query INSERT INTO postgresql_replica_{} select i, i from generate_series(0, 10000) as t(i); query DELETE FROM postgresql_replica_{} WHERE (value*value) % 3 = 0; query UPDATE postgresql_replica_{} SET value = value - 125 WHERE key % 2 = 0; query UPDATE postgresql_replica_{} SET key=key+20000 WHERE key%2=0 query INSERT INTO postgresql_replica_{} select i, i from generate_series(40000, 50000) as t(i); query DELETE FROM postgresql_replica_{} WHERE key % 10 = 0; query UPDATE postgresql_replica_{} SET value = value + 101 WHERE key % 2 = 1; query UPDATE postgresql_replica_{} SET key=key+80000 WHERE key%2=1 query DELETE FROM postgresql_replica_{} WHERE value % 2 = 0; query UPDATE postgresql_replica_{} SET value = value + 2000 WHERE key % 5 = 0; query INSERT INTO postgresql_replica_{} select i, i from generate_series(200000, 250000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 3 = 0; query UPDATE postgresql_replica_{} SET value = value * 2 WHERE key % 3 = 0; query UPDATE postgresql_replica_{} SET key=key+500000 WHERE key%2=1 query INSERT INTO postgresql_replica_{} select i, i from generate_series(1000000, 1050000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 9 = 2; query UPDATE postgresql_replica_{} SET key=key+10000000 query UPDATE postgresql_replica_{} SET value = value + 2 WHERE key % 3 = 1; query DELETE FROM postgresql_replica_{} WHERE value%5 = 0; Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select count() from test_database.postgresql_replica_0 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:16 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:17 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:17 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:17 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:23 [ 511 ] DEBUG : Executing query select count() from test_database.postgresql_replica_0 on instance (cluster.py:3455, query) 2025-06-08 17:44:23 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:23 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:23 [ 511 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:24 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:24 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:24 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:24 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________________________ test_table_schema_changes ___________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_table_schema_changes(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table( f"postgresql_replica_{i}", template=postgres_table_template_2 ) instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT number, {i}, {i}, {i} from numbers(25)" ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 25 + number, {i}, {i}, {i} from numbers(25)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:371: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f2f9bb78ac3 E 20. ? @ 0x00007f2f9bc0a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:25 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:26 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:26 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:26 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:26 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:27 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:27 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:27 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-08 17:44:27 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:27 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:28 [ 511 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:28 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:28 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:28 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:28 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_user_managed_slots ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_user_managed_slots(started_cluster): slot_name = "user_slot" table_name = "test_table" pg_manager.create_and_fill_postgres_table(table_name) replication_connection = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, replication=True, auto_commit=True, ) snapshot = create_replication_slot(replication_connection, slot_name=slot_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, settings=[ f"materialized_postgresql_replication_slot = '{slot_name}'", f"materialized_postgresql_snapshot = '{snapshot}'", ], ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:865: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.test_table' in scope SELECT * FROM `test_database.test_table` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f2f9bb78ac3 E 20. ? @ 0x00007f2f9bc0a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.test_table` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "test_table" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) user_slot 0/82C2020 000000DA-00000002-1 Checking table test_table exists in test_database Checking table is synchronized: test_database.test_table ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`test_table` order by key; on instance Executing query select * from `test_database.test_table` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:29 [ 511 ] DEBUG : Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance (cluster.py:3455, query) 2025-06-08 17:44:29 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:29 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance (cluster.py:3455, query) 2025-06-08 17:44:29 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:30 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:30 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`test_table` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:30 [ 511 ] DEBUG : Executing query select * from `test_database.test_table` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:30 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:30 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:31 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:31 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) _____________________________ test_virtual_columns _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_virtual_columns(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) assert_nested_table_is_created(instance, table_name) instance.query( f"INSERT INTO postgres_database.{table_name} SELECT number, number from numbers(10)" ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:553: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.4.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000003a554b73 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001cb49070 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x000000000c5c35b6 E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:6971: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x000000002dbba909 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000002dbabc57 E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000002dba2d0e E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000002e5ea236 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000002e5e2d54 E 8. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:0: std::__unique_if::__unique_single std::make_unique[abi:v15000]&, std::shared_ptr const&, DB::SelectQueryOptions const&>(std::shared_ptr&, std::shared_ptr const&, DB::SelectQueryOptions const&) @ 0x000000002e5ede81 E 9. ./contrib/llvm-project/libcxx/include/__functional/function.h:0: ? @ 0x000000002e49edbd E 10. ./build_docker/./src/Interpreters/executeQuery.cpp:0: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x000000002f22694a E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000002f21d9ca E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x000000003272de3d E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x0000000032772891 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000003a25ceaf E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000003a25db57 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:0: Poco::PooledThread::run() @ 0x000000003a66ab3c E 17. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000003a663b28 E 18. asan_thread_start(void*) @ 0x000000000a7b9edb E 19. ? @ 0x00007f2f9bb78ac3 E 20. ? @ 0x00007f2f9bc0a850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-08 17:44:31 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:31 [ 511 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:32 [ 511 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-08 17:44:32 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:32 [ 511 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance (cluster.py:3455, query) 2025-06-08 17:44:32 [ 511 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-08 17:44:32 [ 511 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-08 17:44:33 [ 511 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stdout:Total reclaimed space: 0B Images pruned Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:5 ---------------------------- Captured log teardown ----------------------------- 2025-06-08 17:44:33 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-08 17:44:33 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:33 [ 511 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-08 17:44:33 [ 511 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.4.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-08 17:44:34 [ 511 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] (cluster.py:113, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] (cluster.py:113, run_and_check) 2025-06-08 17:44:35 [ 511 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] (cluster.py:113, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default (cluster.py:123, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-08 17:44:36 [ 511 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-08 17:44:36 [ 511 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-08 17:44:36 [ 511 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-08 17:44:36 [ 511 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-08 17:44:36 [ 511 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-08 17:44:36 [ 511 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-08 17:44:36 [ 511 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-08 17:44:36 [ 511 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-08 17:44:36 [ 511 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-08 17:44:37 [ 511 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:121, run_and_check) 2025-06-08 17:44:37 [ 511 ] DEBUG : Images pruned (cluster.py:854, cleanup) 2025-06-08 17:44:37 [ 511 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-08 17:44:37 [ 511 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-08 17:44:37 [ 511 ] DEBUG : Stdout:5 (cluster.py:121, run_and_check) =============================== warnings summary =============================== test_s3_with_https/test.py::test_s3_with_https[s3_secure] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1099: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.8.5'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 300.73s call test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 48.10s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 46.68s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 44.56s setup test_replication_credentials/test.py::test_credentials_and_no_credentials 39.49s call test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 38.18s call test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 35.87s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 34.09s call test_replicated_mutations/test.py::test_mutations 32.88s setup test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 31.18s call test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 30.24s setup test_replicated_mutations/test.py::test_mutations 23.86s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 23.58s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 22.55s teardown test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 22.30s teardown test_s3_imds/test_session_token.py::test_credentials_from_metadata 22.05s call test_replicated_user_defined_functions/test.py::test_reload_zookeeper 22.02s teardown test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 21.67s setup test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 20.83s setup test_replicated_user_defined_functions/test.py::test_create_and_drop 18.59s setup test_replicating_constants/test.py::test_different_versions 18.51s call test_replicated_users/test.py::test_reload_zookeeper 18.33s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 17.91s setup test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 16.53s setup test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 15.00s setup test_quota/test.py::test_add_remove_interval 14.86s call test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 14.59s setup test_reloading_settings_from_users_xml/test.py::test_force_reload 14.35s call test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 14.10s setup test_ssh_keys_authentication/test.py::test_ecdsa 13.92s teardown test_replication_credentials/test.py::test_same_credentials 13.74s setup test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 12.41s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 11.89s setup test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 10.92s teardown test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 10.55s setup test_s3_imds/test_session_token.py::test_credentials_from_metadata 10.37s teardown test_replicated_users/test.py::test_rename_replicated[USER] 9.99s call test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 9.05s teardown test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 8.38s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure] 7.36s setup test_render_log_file_name_templates/test.py::test_check_file_names 7.03s call test_postgresql_replica_database_engine_1/test.py::test_single_transaction 6.83s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 6.51s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 6.26s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 6.10s call test_replicated_user_defined_functions/test.py::test_server_restart 5.14s call test_quota/test.py::test_add_remove_interval 5.08s teardown test_replicating_constants/test.py::test_different_versions 5.02s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 4.68s call test_quota/test.py::test_dcl_introspection 4.67s call test_replication_credentials/test.py::test_different_credentials 4.51s teardown test_quota/test.py::test_users_xml_is_readonly 4.25s teardown test_render_log_file_name_templates/test.py::test_check_file_names 3.96s call test_replication_credentials/test.py::test_credentials_and_no_credentials 3.90s call test_quota/test.py::test_dcl_management 3.89s call test_quota/test.py::test_add_remove_quota 3.81s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 3.75s teardown test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 3.67s teardown test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 3.41s call test_quota/test.py::test_reload_users_xml_by_timer 3.16s call test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 3.16s call test_replicated_user_defined_functions/test.py::test_replication 3.12s call test_replication_credentials/test.py::test_no_credentials 3.10s call test_replication_credentials/test.py::test_same_credentials 2.94s call test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 2.90s call test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 2.59s call test_quota/test.py::test_exceed_quota 2.36s call test_quota/test.py::test_quota_from_users_xml 2.34s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 2.26s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 2.08s call test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 2.00s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 1.99s call test_quota/test.py::test_query_inserts 1.94s teardown test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 1.90s call test_quota/test.py::test_tracking_quota 1.85s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.72s call test_replicated_user_defined_functions/test.py::test_create_and_replace 1.64s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 1.54s call test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 1.52s call test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 1.43s call test_s3_imds/test_session_token.py::test_credentials_from_metadata 1.42s call test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 1.40s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.35s call test_reloading_settings_from_users_xml/test.py::test_force_reload 1.33s call test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 1.30s call test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 1.24s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 1.23s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 1.23s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 1.22s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 1.18s setup test_quota/test.py::test_reload_users_xml_by_timer 1.13s call test_s3_with_https/test.py::test_s3_with_https[s3_secure] 1.12s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 1.11s call test_quota/test.py::test_simpliest_quota 1.10s call test_replicated_users/test.py::test_create_replicated[ROLE] 1.08s call test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 1.06s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 1.05s call test_replicated_users/test.py::test_create_replicated[QUOTA] 1.05s call test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 1.01s call test_replicated_users/test.py::test_rename_replicated[USER] 0.99s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.96s setup test_quota/test.py::test_query_inserts 0.95s setup test_quota/test.py::test_exceed_quota 0.95s call test_replicated_users/test.py::test_create_replicated[USER] 0.93s setup test_quota/test.py::test_users_xml_is_readonly 0.93s teardown test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.92s teardown test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.91s call test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.89s teardown test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.84s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.78s call test_quota/test.py::test_consumption_of_show_privileges 0.76s setup test_quota/test.py::test_quota_from_users_xml 0.75s setup test_quota/test.py::test_dcl_introspection 0.74s call test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.74s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.74s setup test_quota/test.py::test_consumption_of_show_privileges 0.73s teardown test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 0.73s call test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.73s call test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.73s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.71s call test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.69s teardown test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.68s setup test_quota/test.py::test_dcl_management 0.67s call test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.66s setup test_quota/test.py::test_tracking_quota 0.66s setup test_quota/test.py::test_simpliest_quota 0.64s setup test_replication_credentials/test.py::test_no_credentials 0.64s call test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.64s setup test_quota/test.py::test_consumption_of_show_clusters 0.63s call test_replicated_users/test.py::test_rename_replicated[ROLE] 0.63s setup test_quota/test.py::test_add_remove_quota 0.62s setup test_quota/test.py::test_consumption_of_show_tables 0.62s setup test_quota/test.py::test_consumption_of_show_databases 0.61s call test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.61s setup test_quota/test.py::test_consumption_of_show_processlist 0.61s setup test_replication_credentials/test.py::test_different_credentials 0.59s setup test_replication_credentials/test.py::test_same_credentials 0.58s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.53s call test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.53s call test_quota/test.py::test_consumption_of_show_clusters 0.48s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.47s call test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.45s call test_render_log_file_name_templates/test.py::test_check_file_names 0.45s call test_replicated_user_defined_functions/test.py::test_create_and_drop 0.43s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.39s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.38s call test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.38s call test_quota/test.py::test_consumption_of_show_databases 0.38s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.38s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.34s call test_quota/test.py::test_consumption_of_show_processlist 0.34s call test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.33s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.33s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.33s call test_quota/test.py::test_consumption_of_show_tables 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.32s call test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.30s setup test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.28s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 0.27s call test_ssh_keys_authentication/test.py::test_ecdsa 0.27s call test_replicating_constants/test.py::test_different_versions 0.23s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.22s call test_quota/test.py::test_users_xml_is_readonly 0.22s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.21s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.17s call test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s teardown test_replicated_mutations/test.py::test_mutations 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 0.00s setup test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s setup test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 0.00s setup test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 0.00s teardown test_replication_credentials/test.py::test_credentials_and_no_credentials 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.00s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_reload_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 0.00s teardown test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s teardown test_quota/test.py::test_consumption_of_show_tables 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s setup test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s teardown test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s teardown test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s teardown test_quota/test.py::test_add_remove_interval 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s teardown test_ssh_keys_authentication/test.py::test_ecdsa 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 0.00s setup test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s teardown test_quota/test.py::test_add_remove_quota 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s teardown test_quota/test.py::test_consumption_of_show_databases 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.00s teardown test_ssh_keys_authentication/test.py::test_ed25519 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_force_reload 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 0.00s teardown test_quota/test.py::test_dcl_management 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_rename_replicated[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s teardown test_quota/test.py::test_consumption_of_show_clusters 0.00s setup test_replicated_users/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s teardown test_quota/test.py::test_query_inserts 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s setup test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s setup test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_quota/test.py::test_exceed_quota 0.00s teardown test_quota/test.py::test_simpliest_quota 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s teardown test_quota/test.py::test_consumption_of_show_processlist 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_quota/test.py::test_consumption_of_show_privileges 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s teardown test_replication_credentials/test.py::test_different_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_quota/test.py::test_tracking_quota 0.00s teardown test_quota/test.py::test_quota_from_users_xml 0.00s teardown test_quota/test.py::test_reload_users_xml_by_timer 0.00s teardown test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_quota/test.py::test_dcl_introspection 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_replicated_users/test.py::test_create_replicated[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_replication_credentials/test.py::test_no_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] =========================== short test summary info ============================ FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns PASSED test_ssh_keys_authentication/test.py::test_ecdsa PASSED test_ssh_keys_authentication/test.py::test_ed25519 PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout PASSED test_quota/test.py::test_add_remove_interval PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout PASSED test_quota/test.py::test_add_remove_quota PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_clusters PASSED test_replicated_users/test.py::test_create_replicated[ROLE] PASSED test_quota/test.py::test_consumption_of_show_databases PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] PASSED test_quota/test.py::test_consumption_of_show_privileges PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] PASSED test_replicated_users/test.py::test_create_replicated[USER] PASSED test_quota/test.py::test_consumption_of_show_processlist PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] PASSED test_quota/test.py::test_consumption_of_show_tables PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] PASSED test_quota/test.py::test_dcl_introspection PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] PASSED test_quota/test.py::test_dcl_management PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] PASSED test_quota/test.py::test_exceed_quota PASSED test_quota/test.py::test_query_inserts PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials PASSED test_quota/test.py::test_quota_from_users_xml PASSED test_replicated_user_defined_functions/test.py::test_replication PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation PASSED test_replication_credentials/test.py::test_different_credentials PASSED test_quota/test.py::test_reload_users_xml_by_timer PASSED test_quota/test.py::test_simpliest_quota PASSED test_replication_credentials/test.py::test_no_credentials PASSED test_replicated_user_defined_functions/test.py::test_server_restart PASSED test_quota/test.py::test_tracking_quota PASSED test_quota/test.py::test_users_xml_is_readonly PASSED test_render_log_file_name_templates/test.py::test_check_file_names PASSED test_replicated_users/test.py::test_reload_zookeeper PASSED test_replication_credentials/test.py::test_same_credentials PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] PASSED test_replicated_mutations/test.py::test_mutations PASSED test_replicated_users/test.py::test_rename_replicated[USER] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper PASSED test_replicating_constants/test.py::test_different_versions PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss ============= 6 failed, 94 passed, 1 warning in 446.07s (0:07:26) ============== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_a2b39n --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e CLICKHOUSE_USE_OLD_ANALYZER=1 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.